﻿using System;
using System.Linq;
using System.Collections.Generic;
using System.Text;
using System.Data;
namespace CIT.WMS.houseWork.Bll
{
   public class Bllb_IQCDoc_tbid
    {
       public static DataTable QCResult(string SN)
       {
           string sqlcmd = string.Format(@"SELECT *  FROM dbo.T_Bllb_IQCDoc_tbid a
LEFT JOIN dbo.T_Bllb_IQCProduct_tbip b ON a.IQC_NO=b.IQC_NO WHERE b.SERIAL_NUMBER='{0}' and a.RESULT IS NOT NULL", SN);
           return Utils.NMS.QueryDataTable(Utils.uContext, sqlcmd, new CIT.WMS.MESWcf.CmdParameter[0]);
       }       
    }
}
